Release 10.1A: OpenEdge Data Management:
SQL Reference

OpenEdge SQL and ODBC Data Types

This section shows how the OpenEdge® SQL data types are mapped to the standard ODBC data types.

Table 63 shows how the OpenEdge SQL data types are mapped to the standard ODBC data types.

Table 63: OpenEdge SQL and ODBC data types 

Progress data type	ODBC data type
BINARY	SQL_BINARY
BIT	SQL_BIT
CHAR	SQL_CHAR
DATE	SQL_TYPE_DATE
DECIMAL	SQL_DECIMAL
DOUBLE PRECISION	SQL_DOUBLE
FLOAT	SQL_FLOAT
INTEGER	SQL_INTEGER
REAL	SQL_FLOAT
SMALLINT	SQL_SMALLINT
TIME	SQL_TYPE_TIME
TIMESTAMP	SQL_TYPE_TIMESTAMP
TINYINT	SQL_TINYINT
VARBINARY	SQL_VARBINARY
LVARBINARY	SQL_LONGVARBINARY
VARCHAR	SQL_VARCHAR